package com.tj.work.oracletest.dao;

import com.tj.work.oracletest.model.TjTest2;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author tangjing
 * @date 2021/09/29 11:31
 */
@Mapper
public interface OracleMapper {

    @Select("SELECT a.*,b.t_data extraData FROM HR.Tj_TEST2 a LEFT JOIN hr.TJ_TEST b ON a.t_id=b.t_id ORDER BY a.t_update_time DESC ")
    List<TjTest2> selectList();

}
